package com.wyz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wyz.entity.StudentEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author wk
 * @desc
 * @date 2024/12/22 17:46
 */
@Mapper
public interface StudentMapper extends BaseMapper<StudentEntity> {
    @Select("select * from t_student where student_name like CONCAT('%', #{value}, '%') or student_id like CONCAT('%', #{value}, '%')")
    List<StudentEntity> queryStudentByNameOrId(String keyword);


}
